import  pymysql

conn = pymysql.connect(host='192.168.18.13',port=33046,user='root', password='123456', db='zhongyuxuan',charset='utf8')

cursor =conn.cursor()

sql = """create table if not exists movies (id int(10) primary key auto_increment, name varchar(128) not null, pic text)"""

cursor.execute(sql)

cursor.execute("show tables")

print(cursor.fetchall())
